data warehousing - meaning and definition. What is data warehousing
Diclib.com
ChatGPT AI Dictionary
Enter a word or phrase in any language 👆
Language:

Translation and analysis of words by ChatGPT artificial intelligence

On this page you can get a detailed analysis of a word or phrase, produced by the best artificial intelligence technology to date:

  • how the word is used
  • frequency of use
  • it is used more often in oral or written speech
  • word translation options
  • usage examples (several phrases with translation)
  • etymology

What (who) is data warehousing - definition

SYSTEM USED FOR REPORTING AND DATA ANALYSIS, AS A CORE COMPONENT OF BUSINESS INTELLIGENCE
Data Warehouse; Data warehousing; Datawarehouse; Data Warehousing; Datawarehousing; Information warehouse; Data warehouses; DataWarehouse; Data Warehouses; Dimensional database; Data warehouse architectures; Fact (data warehouse); Dataware Housing; Fact Data Warehousing; Integration warehouse; Electronic data processing datawarehouse; Enterprise data warehouse; Enterprise Data Warehouse; History of data warehousing; Data warehouse design
  • Data warehouse overview
  • The basic architecture of a data warehouse
  • ELT]]-based data warehouse architecture

Data warehouse         
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources.
data warehousing         
data warehouse         
<database> (Or corporate data warehouse, CDW) Any system for storing, retrieving and managing large amounts of data. Data warehouse software often includes sophisticated compression and hashing techniques for fast searches, as well as advanced filtering. A data warehouse is often a {relational database} containing a recent snapshot of corporate data and optimised for searching. Planners and researchers can use this database without worrying about slowing down day-to-day operations of the production database. The latter can be optimised for transaction processing (inserts and updates). Compare data mart. (2007-05-16)

Wikipedia

Data warehouse

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. Data warehouses are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise. This is beneficial for companies as it enables them to interrogate and draw insights from their data and make decisions.

The data stored in the warehouse is uploaded from the operational systems (such as marketing or sales). The data may pass through an operational data store and may require data cleansing for additional operations to ensure data quality before it is used in the data warehouse for reporting.

Extract, transform, load (ETL) and extract, load, transform (ELT) are the two main approaches used to build a data warehouse system.

Examples of use of data warehousing
1. Synergies between the two companies will lead to the company emerging as a partner of choice for its customers globally, as it now offers the entire Business Intelligence and Data Warehousing (BI and DW) footprint of intelligence, insight and integration.
2. On Monday, it said it had sold a 37 per cent stake in Global Switch, the data warehousing company, and a 25 per cent holding in London‘s Stratford City project.
3. "This acquisition should accelerate our aspiration of leadership in emerging competencies like business intelligence and analytics; synergising with our demonstrated leadership in data warehousing and data integration", said Ramalinga Raju, founder and chairman, Satyam computer services.